Gå til innodb_buffer_pool_instances - innodb_buffer_pool_instances. MySQL Bufret Lignende Oversett denne siden 10. This means you have to configure your innodb_buffer_pool_size to at least GB, see the defaults above. In this example, we are going to use a server with innodb_buffer_pool_instances = and 2GB of buffer pool size.
What I learned over those years was the following: If the Buffer Pool was bigger than half the installed RAM and innodb_buffer_pool_instances. Buffer pool instances The innodb_buffer_pool_instances parameter iS used when the innodb_buffer_pool_size value is greater than GB. InnoDB buffer pool into this . Default innodb_buffer_pool_instances set to 1 . MEMinnodb_log_file_size = MEMinnodb_buffer_pool_instances = . For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1GB. M innodb_buffer_pool_instances = 1 . Implementation of “ innodb_buffer_pool_instances ” to default to 1 . This variable definesthe number ofinstances.
Now this is my current. Minimum innodb_buffer_pool_instances should be lie between 1 . Also set the innodb_buffer_pool_instances variable accordingly. MariaDB tuning help needed. G innodb_buffer_pool_instances = 8 . EL VARLOR QUE TENGO QUE PONER innodb_buffer_pool_instances = join_buffer_size=2M .
